import os
from openpyxl import load_workbook

file = os.path.join("data", "user_userinfo.xlsx")

wb = load_workbook(file)

sheet = wb.worksheets[0]

# 寻找单元格
# cell = sheet.cell(2, 2)
# print(cell)
# print(cell.value)


# cell = sheet["B2"]
# print(cell.value)


# 寻找某一行
# row = sheet[2]
# print(row)
# print(row[1].value)

# 获取所有行

# for row in sheet.rows:
#     print(row)

for row in sheet.iter_rows(min_row=2, max_row=5):
    print(row[0].value)
